/*
 Navicat Premium Data Transfer

 Source Server         : xtonline
 Source Server Type    : MySQL
 Source Server Version : 50650
 Source Host           : 121.5.10.112:3306
 Source Schema         : account

 Target Server Type    : MySQL
 Target Server Version : 50650
 File Encoding         : 65001

 Date: 11/09/2022 15:48:28
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sys_account_book
-- ----------------------------
DROP TABLE IF EXISTS `sys_account_book`;
CREATE TABLE `sys_account_book` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL COMMENT '账本名称',
  `description` varchar(255) DEFAULT NULL COMMENT '账本描述',
  `img_path` varchar(255) DEFAULT NULL COMMENT '账本背景',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sys_account_book
-- ----------------------------
BEGIN;
INSERT INTO `sys_account_book` VALUES (1, '日常生活', '', '');
INSERT INTO `sys_account_book` VALUES (2, '人情账本', NULL, NULL);
INSERT INTO `sys_account_book` VALUES (3, '装修账本', NULL, NULL);
INSERT INTO `sys_account_book` VALUES (4, '结婚账本', NULL, NULL);
INSERT INTO `sys_account_book` VALUES (5, '出差账本', NULL, NULL);
INSERT INTO `sys_account_book` VALUES (6, '公司账本', NULL, NULL);
INSERT INTO `sys_account_book` VALUES (7, '店铺生意', NULL, NULL);
INSERT INTO `sys_account_book` VALUES (8, '汽车账本', NULL, NULL);
INSERT INTO `sys_account_book` VALUES (9, '其他账本', NULL, NULL);
INSERT INTO `sys_account_book` VALUES (10, '旅行账本', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_account_category
-- ----------------------------
DROP TABLE IF EXISTS `sys_account_category`;
CREATE TABLE `sys_account_category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL COMMENT '用于记账的类目',
  `img_path` varchar(255) DEFAULT NULL COMMENT '类目图片',
  `account_book_id` int(11) DEFAULT NULL COMMENT '所属账本id',
  `type` int(11) DEFAULT NULL COMMENT '类目类别：0支出、1收入',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=150 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sys_account_category
-- ----------------------------
BEGIN;
INSERT INTO `sys_account_category` VALUES (1, '办公', NULL, 1, 0);
INSERT INTO `sys_account_category` VALUES (2, '宠物', NULL, 1, 0);
INSERT INTO `sys_account_category` VALUES (3, '服饰', NULL, 1, 0);
INSERT INTO `sys_account_category` VALUES (4, '购物', NULL, 1, 0);
INSERT INTO `sys_account_category` VALUES (5, '交通', NULL, 1, 0);
INSERT INTO `sys_account_category` VALUES (6, '礼物', NULL, 1, 0);
INSERT INTO `sys_account_category` VALUES (7, '零食', NULL, 1, 0);
INSERT INTO `sys_account_category` VALUES (8, '旅行', NULL, 1, 0);
INSERT INTO `sys_account_category` VALUES (9, '美容', NULL, 1, 0);
INSERT INTO `sys_account_category` VALUES (10, '汽车', NULL, 1, 0);
INSERT INTO `sys_account_category` VALUES (11, '亲友', NULL, 1, 0);
INSERT INTO `sys_account_category` VALUES (12, '社交', NULL, 1, 0);
INSERT INTO `sys_account_category` VALUES (13, '书籍', NULL, 1, 0);
INSERT INTO `sys_account_category` VALUES (14, '蔬菜', NULL, 1, 0);
INSERT INTO `sys_account_category` VALUES (15, '数码', NULL, 1, 0);
INSERT INTO `sys_account_category` VALUES (16, '水果', NULL, 1, 0);
INSERT INTO `sys_account_category` VALUES (17, '通讯', NULL, 1, 0);
INSERT INTO `sys_account_category` VALUES (18, '学习', NULL, 1, 0);
INSERT INTO `sys_account_category` VALUES (19, '烟酒', NULL, 1, 0);
INSERT INTO `sys_account_category` VALUES (20, '医疗', NULL, 1, 0);
INSERT INTO `sys_account_category` VALUES (21, '幼儿', NULL, 1, 0);
INSERT INTO `sys_account_category` VALUES (22, '娱乐', NULL, 1, 0);
INSERT INTO `sys_account_category` VALUES (23, '运动', NULL, 1, 0);
INSERT INTO `sys_account_category` VALUES (24, '长辈', NULL, 1, 0);
INSERT INTO `sys_account_category` VALUES (25, '住房', NULL, 1, 0);
INSERT INTO `sys_account_category` VALUES (26, '其他', NULL, 1, 0);
INSERT INTO `sys_account_category` VALUES (27, '工资', NULL, 1, 1);
INSERT INTO `sys_account_category` VALUES (28, '理财', NULL, 1, 1);
INSERT INTO `sys_account_category` VALUES (29, '兼职', NULL, 1, 1);
INSERT INTO `sys_account_category` VALUES (30, '礼金', NULL, 1, 1);
INSERT INTO `sys_account_category` VALUES (31, '其他', NULL, 1, 1);
INSERT INTO `sys_account_category` VALUES (32, '发红包', NULL, 2, 0);
INSERT INTO `sys_account_category` VALUES (33, '婚嫁随礼', NULL, 2, 0);
INSERT INTO `sys_account_category` VALUES (34, '寿辰', NULL, 2, 0);
INSERT INTO `sys_account_category` VALUES (35, '乔迁', NULL, 2, 0);
INSERT INTO `sys_account_category` VALUES (36, '其他', NULL, 2, 0);
INSERT INTO `sys_account_category` VALUES (37, '收红包', NULL, 2, 1);
INSERT INTO `sys_account_category` VALUES (38, '结婚收礼', NULL, 2, 1);
INSERT INTO `sys_account_category` VALUES (39, '寿辰收礼', NULL, 2, 1);
INSERT INTO `sys_account_category` VALUES (40, '乔迁收礼', NULL, 2, 1);
INSERT INTO `sys_account_category` VALUES (41, '其他', NULL, 2, 1);
INSERT INTO `sys_account_category` VALUES (52, '地板', NULL, 3, 0);
INSERT INTO `sys_account_category` VALUES (53, '瓷砖', NULL, 3, 0);
INSERT INTO `sys_account_category` VALUES (54, '门窗', NULL, 3, 0);
INSERT INTO `sys_account_category` VALUES (55, '线路改造', NULL, 3, 0);
INSERT INTO `sys_account_category` VALUES (56, '厨房', NULL, 3, 0);
INSERT INTO `sys_account_category` VALUES (57, '卫浴', NULL, 3, 0);
INSERT INTO `sys_account_category` VALUES (58, '辅助材料', NULL, 3, 0);
INSERT INTO `sys_account_category` VALUES (59, '家具', NULL, 3, 0);
INSERT INTO `sys_account_category` VALUES (60, '家电', NULL, 3, 0);
INSERT INTO `sys_account_category` VALUES (61, '插座', NULL, 3, 0);
INSERT INTO `sys_account_category` VALUES (62, '灯具', NULL, 3, 0);
INSERT INTO `sys_account_category` VALUES (63, '窗帘', NULL, 3, 0);
INSERT INTO `sys_account_category` VALUES (64, '人工费', NULL, 3, 0);
INSERT INTO `sys_account_category` VALUES (65, '设计费', NULL, 3, 0);
INSERT INTO `sys_account_category` VALUES (66, '装饰物品', NULL, 3, 0);
INSERT INTO `sys_account_category` VALUES (67, '油漆涂料', NULL, 3, 0);
INSERT INTO `sys_account_category` VALUES (68, '其他', NULL, 3, 0);
INSERT INTO `sys_account_category` VALUES (69, '红包', NULL, 3, 1);
INSERT INTO `sys_account_category` VALUES (70, '其他', NULL, 3, 1);
INSERT INTO `sys_account_category` VALUES (71, '聘礼', NULL, 4, 0);
INSERT INTO `sys_account_category` VALUES (72, '首饰', NULL, 4, 0);
INSERT INTO `sys_account_category` VALUES (73, '婚纱摄影', NULL, 4, 0);
INSERT INTO `sys_account_category` VALUES (74, '酒席', NULL, 4, 0);
INSERT INTO `sys_account_category` VALUES (75, '喜帖', NULL, 4, 0);
INSERT INTO `sys_account_category` VALUES (76, '喜糖', NULL, 4, 0);
INSERT INTO `sys_account_category` VALUES (77, '婚庆司仪', NULL, 4, 0);
INSERT INTO `sys_account_category` VALUES (78, '度蜜月', NULL, 4, 0);
INSERT INTO `sys_account_category` VALUES (79, '其他', NULL, 4, 0);
INSERT INTO `sys_account_category` VALUES (80, '红包', NULL, 4, 1);
INSERT INTO `sys_account_category` VALUES (81, '礼金', NULL, 4, 1);
INSERT INTO `sys_account_category` VALUES (82, '其他', NULL, 4, 1);
INSERT INTO `sys_account_category` VALUES (83, '交通', NULL, 5, 0);
INSERT INTO `sys_account_category` VALUES (84, '餐饮', NULL, 5, 0);
INSERT INTO `sys_account_category` VALUES (85, '送礼', NULL, 5, 0);
INSERT INTO `sys_account_category` VALUES (86, '住宿', NULL, 5, 0);
INSERT INTO `sys_account_category` VALUES (87, '宴请招待', NULL, 5, 0);
INSERT INTO `sys_account_category` VALUES (88, '其他', NULL, 5, 0);
INSERT INTO `sys_account_category` VALUES (89, '差旅津贴', NULL, 5, 1);
INSERT INTO `sys_account_category` VALUES (90, '红包', NULL, 5, 1);
INSERT INTO `sys_account_category` VALUES (91, '其他', NULL, 5, 1);
INSERT INTO `sys_account_category` VALUES (92, '员工工资', NULL, 6, 0);
INSERT INTO `sys_account_category` VALUES (93, '五险一金', NULL, 6, 0);
INSERT INTO `sys_account_category` VALUES (94, '员工奖金', NULL, 6, 0);
INSERT INTO `sys_account_category` VALUES (95, '员工团建', NULL, 6, 0);
INSERT INTO `sys_account_category` VALUES (96, '水费电费', NULL, 6, 0);
INSERT INTO `sys_account_category` VALUES (97, '网络通讯', NULL, 6, 0);
INSERT INTO `sys_account_category` VALUES (98, '办公用品', NULL, 6, 0);
INSERT INTO `sys_account_category` VALUES (99, '场地租金', NULL, 6, 0);
INSERT INTO `sys_account_category` VALUES (100, '维修费', NULL, 6, 0);
INSERT INTO `sys_account_category` VALUES (101, '清洁费', NULL, 6, 0);
INSERT INTO `sys_account_category` VALUES (102, '材料费', NULL, 6, 0);
INSERT INTO `sys_account_category` VALUES (103, '物流费', NULL, 6, 0);
INSERT INTO `sys_account_category` VALUES (104, '花卉', NULL, 6, 0);
INSERT INTO `sys_account_category` VALUES (105, '其他', NULL, 6, 0);
INSERT INTO `sys_account_category` VALUES (106, '公司营收', NULL, 6, 1);
INSERT INTO `sys_account_category` VALUES (107, '租赁所得', NULL, 6, 1);
INSERT INTO `sys_account_category` VALUES (108, '政策补贴', NULL, 6, 1);
INSERT INTO `sys_account_category` VALUES (109, '退税收入', NULL, 6, 1);
INSERT INTO `sys_account_category` VALUES (110, '物品转卖', NULL, 6, 1);
INSERT INTO `sys_account_category` VALUES (111, '其他', NULL, 6, 1);
INSERT INTO `sys_account_category` VALUES (112, '员工工资', NULL, 7, 0);
INSERT INTO `sys_account_category` VALUES (113, '进货', NULL, 7, 0);
INSERT INTO `sys_account_category` VALUES (114, '其他材料', NULL, 7, 0);
INSERT INTO `sys_account_category` VALUES (115, '水费电费', NULL, 7, 0);
INSERT INTO `sys_account_category` VALUES (116, '场地租金', NULL, 7, 0);
INSERT INTO `sys_account_category` VALUES (117, '维修费', NULL, 7, 0);
INSERT INTO `sys_account_category` VALUES (118, '清洁费', NULL, 7, 0);
INSERT INTO `sys_account_category` VALUES (119, '物流费', NULL, 7, 0);
INSERT INTO `sys_account_category` VALUES (120, '其他', NULL, 7, 0);
INSERT INTO `sys_account_category` VALUES (121, '店铺收入', NULL, 7, 1);
INSERT INTO `sys_account_category` VALUES (122, '物品转卖', NULL, 7, 1);
INSERT INTO `sys_account_category` VALUES (123, '其他', NULL, 7, 1);
INSERT INTO `sys_account_category` VALUES (124, '油费', NULL, 8, 0);
INSERT INTO `sys_account_category` VALUES (125, '停车费', NULL, 8, 0);
INSERT INTO `sys_account_category` VALUES (126, '洗车', NULL, 8, 0);
INSERT INTO `sys_account_category` VALUES (127, '过路费', NULL, 8, 0);
INSERT INTO `sys_account_category` VALUES (128, '罚款', NULL, 8, 0);
INSERT INTO `sys_account_category` VALUES (129, '维修保养', NULL, 8, 0);
INSERT INTO `sys_account_category` VALUES (130, '车贷', NULL, 8, 0);
INSERT INTO `sys_account_category` VALUES (131, '配件', NULL, 8, 0);
INSERT INTO `sys_account_category` VALUES (132, '车检', NULL, 8, 0);
INSERT INTO `sys_account_category` VALUES (133, '车险', NULL, 8, 0);
INSERT INTO `sys_account_category` VALUES (134, '购车款', NULL, 8, 0);
INSERT INTO `sys_account_category` VALUES (135, '其他', NULL, 8, 0);
INSERT INTO `sys_account_category` VALUES (136, '其他', NULL, 8, 1);
INSERT INTO `sys_account_category` VALUES (137, '其他', NULL, 9, 0);
INSERT INTO `sys_account_category` VALUES (138, '其他', NULL, 9, 1);
INSERT INTO `sys_account_category` VALUES (139, '餐饮', '', 1, 0);
INSERT INTO `sys_account_category` VALUES (140, '吃喝', NULL, 10, 0);
INSERT INTO `sys_account_category` VALUES (141, '交通', NULL, 10, 0);
INSERT INTO `sys_account_category` VALUES (142, '门票', NULL, 10, 0);
INSERT INTO `sys_account_category` VALUES (143, '住宿', NULL, 10, 0);
INSERT INTO `sys_account_category` VALUES (144, '娱乐', NULL, 10, 0);
INSERT INTO `sys_account_category` VALUES (145, '装备', NULL, 10, 0);
INSERT INTO `sys_account_category` VALUES (146, '运动', NULL, 10, 0);
INSERT INTO `sys_account_category` VALUES (147, '其他', NULL, 10, 0);
INSERT INTO `sys_account_category` VALUES (148, '红包', NULL, 10, 1);
INSERT INTO `sys_account_category` VALUES (149, '其他', NULL, 10, 1);
COMMIT;

-- ----------------------------
-- Table structure for sys_app_update
-- ----------------------------
DROP TABLE IF EXISTS `sys_app_update`;
CREATE TABLE `sys_app_update` (
  `id` int(11) NOT NULL,
  `is_force` int(11) DEFAULT '1' COMMENT '是否强制法更新，0 否，1 是',
  `is_selected` int(11) DEFAULT '0' COMMENT '是否被选中为更新，0 否，1 是',
  `version` varchar(255) DEFAULT NULL COMMENT '更新展示的版本号',
  `build_num` int(11) DEFAULT NULL COMMENT '更新的编译号',
  `content` varchar(255) DEFAULT NULL COMMENT '更新内容',
  `url` varchar(255) DEFAULT NULL COMMENT '更新链接',
  `create_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sys_app_update
-- ----------------------------
BEGIN;
INSERT INTO `sys_app_update` VALUES (1, 0, 0, '1.0.1', 1, '优化功能！', 'http://acweb.xintangtech.cn/apk/棠迹.apk', '2022-08-28 16:54:29');
COMMIT;

-- ----------------------------
-- Table structure for sys_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_log`;
CREATE TABLE `sys_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL COMMENT '用户id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `oper_cont` varchar(255) DEFAULT NULL COMMENT '操作内容',
  `type` int(11) DEFAULT NULL COMMENT '日志类型：0登录',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=162 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sys_log
-- ----------------------------
BEGIN;
INSERT INTO `sys_log` VALUES (57, 44, '2022-08-17 16:19:44', '微信新增，登录成功', 0);
INSERT INTO `sys_log` VALUES (58, 44, '2022-08-17 16:30:09', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (59, 44, '2022-08-17 16:37:26', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (60, 44, '2022-08-17 16:40:04', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (61, 44, '2022-08-17 17:23:53', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (62, 44, '2022-08-17 18:00:41', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (63, 44, '2022-08-17 18:02:42', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (64, 44, '2022-08-17 18:08:32', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (65, 44, '2022-08-17 18:16:25', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (66, 44, '2022-08-17 22:42:44', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (67, 44, '2022-08-17 23:57:01', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (68, 44, '2022-08-18 00:23:10', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (69, 44, '2022-08-18 14:06:35', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (70, 44, '2022-08-18 15:03:47', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (71, 44, '2022-08-18 15:41:48', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (72, 44, '2022-08-18 18:50:52', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (73, 44, '2022-08-18 19:16:11', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (74, 44, '2022-08-18 21:16:21', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (75, 44, '2022-08-18 22:34:30', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (76, 44, '2022-08-18 22:34:57', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (77, 44, '2022-08-18 22:41:08', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (78, 44, '2022-08-18 23:04:36', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (79, 44, '2022-08-18 23:05:42', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (80, 44, '2022-08-19 09:51:46', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (81, 44, '2022-08-19 10:11:56', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (82, 44, '2022-08-19 10:48:17', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (83, 44, '2022-08-19 11:04:03', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (84, 44, '2022-08-19 11:05:30', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (85, 44, '2022-08-19 11:28:04', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (86, 44, '2022-08-19 11:47:47', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (87, 44, '2022-08-19 14:19:43', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (88, 44, '2022-08-19 14:20:51', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (89, 44, '2022-08-19 14:45:49', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (90, 44, '2022-08-21 22:57:04', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (91, 44, '2022-08-21 23:11:09', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (92, 44, '2022-08-21 23:13:05', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (93, 44, '2022-08-21 23:13:46', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (94, 44, '2022-08-21 23:15:11', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (95, 44, '2022-08-22 22:40:26', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (96, 44, '2022-08-22 22:42:31', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (97, 44, '2022-08-22 23:54:53', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (98, 44, '2022-08-23 00:07:17', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (99, 44, '2022-08-23 00:14:05', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (100, 44, '2022-08-23 00:47:20', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (101, 44, '2022-08-23 00:48:54', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (102, 44, '2022-08-23 00:51:39', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (103, 44, '2022-08-23 00:54:32', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (104, 44, '2022-08-23 00:56:17', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (105, 44, '2022-08-27 18:54:03', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (106, 44, '2022-08-27 19:54:27', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (107, 44, '2022-08-27 19:56:15', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (108, 44, '2022-08-27 19:59:01', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (109, 44, '2022-08-27 20:00:49', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (110, 44, '2022-08-27 20:03:06', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (111, 44, '2022-08-27 20:04:37', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (112, 44, '2022-08-28 15:57:47', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (113, 44, '2022-08-28 16:05:59', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (114, 44, '2022-08-28 16:48:49', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (115, 44, '2022-08-28 17:00:59', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (116, NULL, '2022-08-30 22:57:44', '账号登录成功', 0);
INSERT INTO `sys_log` VALUES (117, NULL, '2022-08-30 23:08:21', '账号登录成功', 0);
INSERT INTO `sys_log` VALUES (118, NULL, '2022-08-30 23:11:22', '账号登录成功', 0);
INSERT INTO `sys_log` VALUES (119, NULL, '2022-08-30 23:17:26', '账号登录成功', 0);
INSERT INTO `sys_log` VALUES (120, NULL, '2022-08-30 23:17:40', '账号登录成功', 0);
INSERT INTO `sys_log` VALUES (121, NULL, '2022-08-30 23:23:18', '账号登录成功', 0);
INSERT INTO `sys_log` VALUES (122, NULL, '2022-08-31 00:03:55', '账号登录成功', 0);
INSERT INTO `sys_log` VALUES (123, NULL, '2022-08-31 00:04:21', '账号登录成功', 0);
INSERT INTO `sys_log` VALUES (124, NULL, '2022-09-02 00:19:21', '账号登录成功', 0);
INSERT INTO `sys_log` VALUES (125, NULL, '2022-09-02 18:57:37', '账号登录成功', 0);
INSERT INTO `sys_log` VALUES (126, 45, '2022-09-02 19:12:36', '微信新增，登录成功', 0);
INSERT INTO `sys_log` VALUES (127, 45, '2022-09-02 19:13:57', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (128, 45, '2022-09-02 19:15:00', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (129, 45, '2022-09-02 19:18:36', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (130, 45, '2022-09-02 19:19:43', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (131, 45, '2022-09-02 19:23:23', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (132, 46, '2022-09-02 19:30:13', '微信新增，登录成功', 0);
INSERT INTO `sys_log` VALUES (133, 46, '2022-09-02 19:34:27', '微信修改，登录成功', 0);
INSERT INTO `sys_log` VALUES (134, NULL, '2022-09-04 17:40:42', '账号登录成功', 0);
INSERT INTO `sys_log` VALUES (135, NULL, '2022-09-04 17:43:38', '账号登录成功', 0);
INSERT INTO `sys_log` VALUES (136, NULL, '2022-09-04 18:06:07', '账号登录成功', 0);
INSERT INTO `sys_log` VALUES (137, 47, '2022-09-09 14:35:18', '微信新增，登录成功', 0);
INSERT INTO `sys_log` VALUES (138, NULL, '2022-09-09 14:38:08', '账号登录成功', 0);
INSERT INTO `sys_log` VALUES (139, NULL, '2022-09-10 10:57:15', '账号登录成功', 0);
INSERT INTO `sys_log` VALUES (140, NULL, '2022-09-10 11:03:34', '账号登录成功', 0);
INSERT INTO `sys_log` VALUES (141, NULL, '2022-09-10 11:22:12', '账号登录成功', 0);
INSERT INTO `sys_log` VALUES (142, NULL, '2022-09-10 11:23:58', '账号登录成功', 0);
INSERT INTO `sys_log` VALUES (143, NULL, '2022-09-10 11:41:13', '账号登录成功', 0);
INSERT INTO `sys_log` VALUES (144, NULL, '2022-09-10 19:22:57', '账号登录成功', 0);
INSERT INTO `sys_log` VALUES (145, NULL, '2022-09-10 19:23:32', '账号登录成功', 0);
INSERT INTO `sys_log` VALUES (146, NULL, '2022-09-10 22:30:56', '账号登录成功', 0);
INSERT INTO `sys_log` VALUES (147, NULL, '2022-09-10 22:51:49', '账号登录成功', 0);
INSERT INTO `sys_log` VALUES (148, NULL, '2022-09-11 00:23:07', '账号登录成功', 0);
INSERT INTO `sys_log` VALUES (149, NULL, '2022-09-11 00:40:37', '账号登录成功', 0);
INSERT INTO `sys_log` VALUES (150, NULL, '2022-09-11 00:45:23', '账号登录成功', 0);
INSERT INTO `sys_log` VALUES (151, NULL, '2022-09-11 00:49:08', '账号登录成功', 0);
INSERT INTO `sys_log` VALUES (152, NULL, '2022-09-11 00:50:38', '账号登录成功', 0);
INSERT INTO `sys_log` VALUES (153, NULL, '2022-09-11 00:52:14', '账号登录成功', 0);
INSERT INTO `sys_log` VALUES (154, NULL, '2022-09-11 11:01:32', '账号登录成功', 0);
INSERT INTO `sys_log` VALUES (155, NULL, '2022-09-11 11:04:53', '账号登录成功', 0);
INSERT INTO `sys_log` VALUES (156, NULL, '2022-09-11 11:12:24', '账号登录成功', 0);
INSERT INTO `sys_log` VALUES (157, NULL, '2022-09-11 11:17:18', '账号登录成功', 0);
INSERT INTO `sys_log` VALUES (158, NULL, '2022-09-11 11:21:58', '账号登录成功', 0);
INSERT INTO `sys_log` VALUES (159, NULL, '2022-09-11 14:57:16', '账号登录成功', 0);
INSERT INTO `sys_log` VALUES (160, NULL, '2022-09-11 15:39:08', '账号登录成功', 0);
INSERT INTO `sys_log` VALUES (161, NULL, '2022-09-11 15:42:09', '账号登录成功', 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_reward
-- ----------------------------
DROP TABLE IF EXISTS `sys_reward`;
CREATE TABLE `sys_reward` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL COMMENT '用户id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `num` int(11) NOT NULL DEFAULT '0' COMMENT '获得奖励数量',
  `type` int(11) NOT NULL DEFAULT '0' COMMENT '奖励类型：0激励视频、1开屏、2banner、3信息流、4插屏',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sys_reward
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户id',
  `name` varchar(255) DEFAULT NULL COMMENT '用户昵称',
  `password` varchar(255) DEFAULT NULL COMMENT '用户密码',
  `avatar` varchar(255) DEFAULT NULL COMMENT '用户头像',
  `token` varchar(255) DEFAULT NULL COMMENT '用户token',
  `day_bean_num` int(11) DEFAULT NULL COMMENT '今日豆',
  `sum_bean_num` int(11) DEFAULT NULL COMMENT '总豆',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '用户创建时间',
  `openid` varchar(255) DEFAULT NULL COMMENT '微信登录id',
  `sex` int(11) DEFAULT NULL COMMENT '1为男性，2为女性',
  `province` varchar(255) DEFAULT NULL COMMENT '省份',
  `city` varchar(255) DEFAULT NULL COMMENT '城市',
  `country` varchar(255) DEFAULT NULL COMMENT '国家',
  `modify_time` timestamp NULL DEFAULT NULL COMMENT '用户修改时间',
  `def_acbook_id` int(11) DEFAULT NULL COMMENT '默认选择的账本id',
  `def_acbook_name` varchar(255) DEFAULT NULL COMMENT '默认选择的账本名称',
  `account` varchar(255) DEFAULT NULL COMMENT '用户账号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` VALUES (44, '小李', '123456', 'https://fc1tn.baidu.com/it/u=659687351,3180592754&fm=202&mola=new&crop=v1', '31fb1c8877ef50d2f47d4ec9a0a20ae1', NULL, NULL, '2022-08-17 16:19:44', 'dgshdghkjHDJKAhdjkHjksadhasDJkhjdahd', 1, '四川', '成都', '中国', '2022-09-11 15:42:09', 44, '公司账本', '18888888888');
INSERT INTO `sys_user` VALUES (45, '木子李', NULL, 'https://thirdwx.qlogo.cn/mmopen/vi_32/sbwiccJaO4H7CIfa9D1GVXicTBP42LXKTZ9RsYD646oCDbf7bgzBhhRFTSDLFGAGpq5vyO73w153eAkfYMTGS3AQ/132', '966ab4c0dd56080cf4dac37849a95461', NULL, NULL, '2022-09-02 19:12:36', 'oU4ky6VvCl-K0gd16lX1we7jd0_Q', 0, '', '', '', '2022-09-02 19:23:23', 46, '日常生活', NULL);
INSERT INTO `sys_user` VALUES (46, '行し、を大切に', NULL, 'https://thirdwx.qlogo.cn/mmopen/vi_32/THIzIFicoaxicV71sZPxe4ZPyhktu1w1O685RP3T1vpXy7dSuXOuS6QPlfaD1gKwzq2ibwnZmly1beAdCwGdKuZjg/132', '1c68c9aa49d35a0708fcadda3c32cdd6', NULL, NULL, '2022-09-02 19:30:13', 'oU4ky6eIRq9WxLqbFOuRo6XAD8jI', 0, '', '', '', '2022-09-02 19:34:27', 47, '日常生活', NULL);
INSERT INTO `sys_user` VALUES (47, '小华', NULL, 'https://thirdwx.qlogo.cn/mmopen/vi_32/KZNCcRkjg2NNmqtz9nzS6UOLxV8QgewOicwiaZwPEvpnXvicww86J1LTZ2xerVqqebNmVaoWRfTic7P8lRwwlmfwwg/132', '6100b0a9e9f496c101d089b2fc9302f1', NULL, NULL, '2022-09-09 14:35:18', 'oU4ky6e9Mn5O8T8WawwzmF5G68a0', 0, '', '', '', NULL, 48, '日常生活', NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_user_account
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_account`;
CREATE TABLE `sys_user_account` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL COMMENT '用户id',
  `account_book_id` int(11) DEFAULT NULL COMMENT '账本id',
  `account_category_id` int(11) DEFAULT NULL COMMENT '记账类目id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `modify_time` datetime DEFAULT NULL COMMENT '修改时间',
  `user_acbook_id` int(11) DEFAULT NULL COMMENT '用户创建的账本id',
  `acbook_type` int(11) DEFAULT NULL COMMENT '账本类型：0支出，1收入',
  `remark` varchar(255) DEFAULT NULL COMMENT '记账的备注',
  `money` varchar(255) DEFAULT NULL COMMENT '记账的金额',
  `money_time` datetime DEFAULT NULL COMMENT '记录账单所在的时间',
  `is_delete` int(11) DEFAULT '0' COMMENT '是否删除，默认为0：没有删除，1：删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sys_user_account
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_account` VALUES (3, 44, 6, 98, '2022-08-17 16:23:23', NULL, 44, 0, '测试办公账单', '8', '2022-08-17 16:23:21', 0);
INSERT INTO `sys_user_account` VALUES (4, 44, 1, 139, '2022-08-17 16:25:10', NULL, 42, 0, '测试日常', '16', '2022-08-17 16:25:05', 0);
INSERT INTO `sys_user_account` VALUES (5, 44, 6, 92, '2022-08-18 00:22:24', NULL, 44, 0, '测试1', '11', '2022-08-18 00:22:21', 0);
INSERT INTO `sys_user_account` VALUES (6, 44, 6, 97, '2022-08-18 00:22:44', NULL, 44, 0, '测试2', '255', '2022-08-18 00:22:41', 1);
INSERT INTO `sys_user_account` VALUES (7, 44, 6, 96, '2022-08-18 00:25:09', NULL, 44, 0, '测试3', '50', '2022-08-18 00:25:07', 1);
INSERT INTO `sys_user_account` VALUES (8, 44, 6, 102, '2022-08-18 00:25:26', NULL, 44, 0, '测试4', '71', '2022-08-18 00:25:23', 0);
INSERT INTO `sys_user_account` VALUES (9, 44, 6, 104, '2022-08-18 14:10:06', NULL, 44, 0, '', '5222', '2022-08-18 14:08:28', 0);
INSERT INTO `sys_user_account` VALUES (10, 44, 6, 111, '2022-08-18 15:41:58', NULL, 44, 1, '测试收入', '1000', '2022-08-18 15:41:54', 0);
INSERT INTO `sys_user_account` VALUES (11, 44, 6, 101, '2022-08-18 21:27:02', NULL, 44, 0, '清洁', '66', '2022-08-18 21:26:55', 1);
INSERT INTO `sys_user_account` VALUES (12, 44, 6, 111, '2022-08-18 21:50:47', NULL, 44, 1, '获得收入', '8.88', '2022-08-18 21:50:42', 1);
INSERT INTO `sys_user_account` VALUES (13, 44, 6, 106, '2022-08-18 21:57:20', NULL, 44, 1, '营收收入', '100000', '2022-08-18 21:57:17', 0);
INSERT INTO `sys_user_account` VALUES (14, 44, 6, 106, '2022-08-23 00:14:35', NULL, 44, 1, '测试', '1000', '2022-08-23 00:14:32', 1);
INSERT INTO `sys_user_account` VALUES (15, 44, 6, 108, '2022-08-23 00:15:01', NULL, 44, 1, '测试', '150866', '2022-08-26 00:00:00', 1);
INSERT INTO `sys_user_account` VALUES (16, 44, 6, 94, '2022-08-27 22:46:31', '2022-08-27 22:47:42', 44, 0, '员工奖金测试', '89', '2022-08-27 22:49:21', 0);
INSERT INTO `sys_user_account` VALUES (17, 44, 6, 108, '2022-08-27 22:47:10', NULL, 44, 1, '补贴测试1', '99', '2022-08-27 23:02:02', 0);
INSERT INTO `sys_user_account` VALUES (18, 44, 6, 97, '2022-08-30 22:58:08', NULL, 44, 0, '测试通讯', '5000', '2022-08-02 00:00:00', 0);
INSERT INTO `sys_user_account` VALUES (19, 44, 6, 96, '2022-08-30 22:58:37', NULL, 44, 0, '水电费支出', '2000', '2022-08-04 00:00:00', 0);
INSERT INTO `sys_user_account` VALUES (20, 44, 6, 97, '2022-08-30 22:59:04', NULL, 44, 0, '电话费', '100', '2022-09-01 00:00:00', 0);
INSERT INTO `sys_user_account` VALUES (21, 44, 6, 96, '2022-08-30 22:59:34', NULL, 44, 0, '水电费', '500', '2022-09-03 00:00:00', 0);
INSERT INTO `sys_user_account` VALUES (22, 44, 6, 111, '2022-08-30 23:00:21', NULL, 44, 1, '其他收入', '8000', '2022-08-30 23:00:00', 0);
INSERT INTO `sys_user_account` VALUES (23, 44, 6, 108, '2022-08-30 23:01:15', NULL, 44, 1, '补贴', '800', '2022-09-01 00:00:00', 0);
INSERT INTO `sys_user_account` VALUES (24, 44, 6, 111, '2022-08-30 23:01:42', NULL, 44, 1, '其他收入', '1000', '2022-09-01 00:00:00', 0);
INSERT INTO `sys_user_account` VALUES (25, 44, 6, 111, '2022-08-30 23:02:35', NULL, 44, 1, '收入', '2000', '2022-09-03 00:00:00', 0);
INSERT INTO `sys_user_account` VALUES (26, 46, 1, 18, '2022-09-02 19:33:06', NULL, 47, 0, '本科报名', '1998', '2022-09-02 19:32:46', 1);
COMMIT;

-- ----------------------------
-- Table structure for sys_user_account_book
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_account_book`;
CREATE TABLE `sys_user_account_book` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL COMMENT '创建账本的用户id',
  `account_book_id` int(11) DEFAULT NULL COMMENT '对应的账本id',
  `create_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `description` varchar(255) DEFAULT NULL COMMENT '账本描述',
  `is_delete` int(11) DEFAULT '0' COMMENT '是否删除，默认为0：没有删除，1：删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sys_user_account_book
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_account_book` VALUES (42, 44, 1, '2022-08-17 16:19:44', '', 0);
INSERT INTO `sys_user_account_book` VALUES (43, 44, 2, '2022-08-17 16:21:09', '测试人情账本1', 0);
INSERT INTO `sys_user_account_book` VALUES (44, 44, 6, '2022-08-17 16:22:39', '测试公司账本', 0);
INSERT INTO `sys_user_account_book` VALUES (45, 44, 8, '2022-08-19 11:51:50', '骑车', 0);
INSERT INTO `sys_user_account_book` VALUES (46, 45, 1, '2022-09-02 19:12:36', '', 0);
INSERT INTO `sys_user_account_book` VALUES (47, 46, 1, '2022-09-02 19:30:13', '', 0);
INSERT INTO `sys_user_account_book` VALUES (48, 47, 1, '2022-09-09 14:35:18', '', 0);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
